home *** CD-ROM | disk | FTP | other *** search
/ Personal Computer World 2009 February / PCWFEB09.iso / Software / Shareware / WorkTime 4.14 / worktime.exe / {app} / Reports / web_log.ini
INI File  |  2007-04-19  |  783b  |  31 lines
  1. [Common]
  2. Name=Web Usage Log
  3. Description=Web Usage Log (Internet Explorer)
  4. AllowFilterAppDoc=1
  5. NeedJoinAppDocInFilter=0    
  6.  
  7. [SQL]
  8. select
  9. Stat.datee "Date",
  10. p.name "Project",
  11. a.name "Activity",
  12. u.name "User",
  13. w.name "Workstation",
  14. doc.name "Caption",
  15. doc.url,
  16. cast(Stat.begin_time as time) Begin_time,
  17. cast(Stat.end_time as time) End_time,
  18. (select FullTimeStr from ConvertIntToTimeStr(Stat.WorkTime)) "Worktime"
  19.  
  20. from detail_day Stat
  21. join project p on Stat.project_id=p.id
  22. join activity a on Stat.activity_id=a.id
  23. join userr u on Stat.user_id=u.id
  24. join workstation w on Stat.workstation_id=w.id
  25. join app on Stat.app_id=app.id
  26. join doc on Stat.doc_id=doc.id
  27. %FROM%
  28. where
  29. Worktime>0 and app.exe_filename='iexplore.exe'
  30. %AND%
  31. order by datee,begin_time, stat.id